UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fLn+aycJFFKFg7wWM1URsIgEVcWhe3XpNTCAdlcbSu8='
WHERE
key_id = '976c1ab8d33532ba0a6985b3940b8f18f1f8d3113405ddaa58e57b16aac0de13'
AND (
token = 'fLn+aycJFFKFg7wWM1URsIgEVcWhe3XpNTCAdlcbSu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)