UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YbNI4ckbiXkmCwTxzBYtwP/puEkFv4l9pwwieKM8GuE='
WHERE
key_id = '07c6208077895166bede52d983bb5ff07a1700d1cd2c1c1a895b9c4e6999b851'
AND (
token = 'YbNI4ckbiXkmCwTxzBYtwP/puEkFv4l9pwwieKM8GuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)