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