UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2G215iaIm9epM1DWXmXpIB9bfpA7dXFeB17yhzA1BPM='
WHERE
key_id = 'bc44cd13f4e336391620ec467f6031b5aecc90d0211ec03a21df44087f4bc311'
AND (
token = '2G215iaIm9epM1DWXmXpIB9bfpA7dXFeB17yhzA1BPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)