UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B+v7MKWvBZ8HH8szPup1NPJN7QL4xi166Fbu/u4WqwM='
WHERE
key_id = '7be9d3932e3c5068477467c40a09bb5e7e3743c3095987eb0059af360aa7c360'
AND (
token = 'B+v7MKWvBZ8HH8szPup1NPJN7QL4xi166Fbu/u4WqwM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)