UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tQGyJne0WUQxnPoXU0HJYEWwkbE+lXXSu1w/J652cqE='
WHERE
key_id = '2e6ee2339adaef74b7709d0bc64ce121ab88305502eaf268f024ef5165d29894'
AND (
token = 'tQGyJne0WUQxnPoXU0HJYEWwkbE+lXXSu1w/J652cqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)