UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B4JqmDYZIY0gK2bBgVZRO91FoKzy1lNEacLcNcRWoKE='
WHERE
key_id = 'efeeb2e6fde45f5561700d30274e3b920675605d78f11722af94a0df4c409760'
AND (
token = 'B4JqmDYZIY0gK2bBgVZRO91FoKzy1lNEacLcNcRWoKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)