UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p9TKyPoz0i/z8mbgkwzE3TfzwE0MVxoI8lCLyvk4nPI='
WHERE
key_id = '6b2cffadada28cf7d7b91e462258110a6d29027025f37c54dda384dba323ff5e'
AND (
token = 'p9TKyPoz0i/z8mbgkwzE3TfzwE0MVxoI8lCLyvk4nPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)