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