UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6xJq1pu8PB09zdqh+SjDEoiPM6G76hini8LEZLcsrbE='
WHERE
key_id = 'cc247dffdd7c1390bc9c4d5c83eced77404a3bf2f478364c3f35061fa4d5ffb2'
AND (
token = '6xJq1pu8PB09zdqh+SjDEoiPM6G76hini8LEZLcsrbE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)