UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nNZdI66HNOaqiAFKTZYgD0PPq6XVwKuSBuupYnAkzCs='
WHERE
key_id = '40c6f45364179bafe4b66109acadc2e0ed52e363257e5bab66e60c05f1ab47e7'
AND (
token = 'nNZdI66HNOaqiAFKTZYgD0PPq6XVwKuSBuupYnAkzCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)