UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6NrrL66lGKkfNFm/zpJWJuAC1TRFvgsnjgEKDoBVkvU='
WHERE
key_id = 'aa0a4c7e7acf2596f24e78f7e2749ed82f5302c12fc7d8de96faca087a851f97'
AND (
token = '6NrrL66lGKkfNFm/zpJWJuAC1TRFvgsnjgEKDoBVkvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)