UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yQdstOIoVeWuEykuvuEXk1O8MqykxqW3gUHbS02jgyA='
WHERE
key_id = '4d5288431f45b19dc316e7b2063b35c15d17225017989731994c50939d0b8bd5'
AND (
token = 'yQdstOIoVeWuEykuvuEXk1O8MqykxqW3gUHbS02jgyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)