UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vO+KOYKCtKpnoiH6HoTbFmfocS3ofUajLebidb0cmHk='
WHERE
key_id = '7786ab48e89facc00cfa5b5bccb2161ac9ad911ece9c0791565e5b63c6be77a9'
AND (
token = 'vO+KOYKCtKpnoiH6HoTbFmfocS3ofUajLebidb0cmHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)