UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O/CTeoRg3DPskbC4iLkJ9opYY24d9I2GwHVJ/XRS5eo='
WHERE
key_id = 'e293e0d9f463014bf88a8e3228648fcab40d7d592ea433e496f833295ff07b71'
AND (
token = 'O/CTeoRg3DPskbC4iLkJ9opYY24d9I2GwHVJ/XRS5eo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)