UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BRVdMxhrA9kLEgy5im+sXlMls10Y0tvcrAq99BufL0E='
WHERE
key_id = 'd015f8235d0a9ca08f523c392306408cdf0dbd10b75c807f2ab88a94e4bffc0a'
AND (
token = 'BRVdMxhrA9kLEgy5im+sXlMls10Y0tvcrAq99BufL0E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)