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