UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YVQ64xYBZRB7tNxNr4bVghYt7aPytaH4HE79jSJjlHM='
WHERE
key_id = 'a1704a88251e02c782df07c82f596308084e790ee7559ef5206abb9b94cc6910'
AND (
token = 'YVQ64xYBZRB7tNxNr4bVghYt7aPytaH4HE79jSJjlHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)