UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y7f0TQM2E8sJ+Aa8x07AGzZh3+K9kXdni8qle7GTKyI='
WHERE
key_id = 'a7b77f30df1eb906a5586eb0e53e90457e130ae2918b880a8822e462c62c8bad'
AND (
token = 'Y7f0TQM2E8sJ+Aa8x07AGzZh3+K9kXdni8qle7GTKyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)