UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n4HlMf1AQB5wZKao7umTA3FFx7/5OfNGqS3CFR3nXoM='
WHERE
key_id = '03c97683ae343b1bc38f6da4de75602be763ad00d743d5ce0d26e91afc7d8795'
AND (
token = 'n4HlMf1AQB5wZKao7umTA3FFx7/5OfNGqS3CFR3nXoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)