UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aYvcPI1CgqxK5X6xhxWbQ7EEq373Mc9Z2jqZ0Ab8ySg='
WHERE
key_id = '27aa5301e337658e5eb068871969cc63494d8b3dd69657920cffe81ca04d0704'
AND (
token = 'aYvcPI1CgqxK5X6xhxWbQ7EEq373Mc9Z2jqZ0Ab8ySg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)