UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XVYpnXVY2krlMMRGeRe87gf0pEB2NiCjPSGTDeH9gO8='
WHERE
key_id = '98932f6deab442653211fc487aa0212e15b9dc054e2b389f187a26137a9eccd9'
AND (
token = 'XVYpnXVY2krlMMRGeRe87gf0pEB2NiCjPSGTDeH9gO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)