UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e9HVZMhlZLcDD23omnWIlIsat7aaYZ2NtF+d/532BGE='
WHERE
key_id = '4db80a98132f6a9ae19469779357ee77ae6ea6f587b6c7708e0433008fb1401c'
AND (
token = 'e9HVZMhlZLcDD23omnWIlIsat7aaYZ2NtF+d/532BGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)