UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rG1eH9FxZ1e1DaUscN4srky7SJHcoaS+15KFr8xv6J8='
WHERE
key_id = '8fe2fb7efc2a6c475c2efa286f91165b87655cf98f0e6b844018fb66dee65da8'
AND (
token = 'rG1eH9FxZ1e1DaUscN4srky7SJHcoaS+15KFr8xv6J8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)