UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tjU6Dh6fRQsSCzQIRxCiUigGj5wS+HEngV6t+3G15R0='
WHERE
key_id = '9689d8d6aa04f8d6b2dddeb9173056565792eec7ad1d6b35dd0f23f27d7eb799'
AND (
token = 'tjU6Dh6fRQsSCzQIRxCiUigGj5wS+HEngV6t+3G15R0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)