UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qZZzsFVEK+/4Pqx4ZdxMyLIpUvu65QDmbZABp0ot25k='
WHERE
key_id = 'd1e36b58f909aff67f8dda73f18bac809494b356f5273d08142889f7e8d2d161'
AND (
token = 'qZZzsFVEK+/4Pqx4ZdxMyLIpUvu65QDmbZABp0ot25k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)