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