UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dG+GmJhaXzrRVQE31ooHsiEr39TeqE8CR4JLkSMHKQI='
WHERE
key_id = 'b890727bf8be8026d56fafd2ee3b3436f26466f1db928d7e1843f376b18a4aa3'
AND (
token = 'dG+GmJhaXzrRVQE31ooHsiEr39TeqE8CR4JLkSMHKQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)