UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DW+xZKP1TwfZ9qlE61aip7wUl5KM50zujogjOnXiw8Q='
WHERE
key_id = '8d513152a9aad708b9cc4e7608017efc4248bb7ac4d93a663229c145ae7e17dd'
AND (
token = 'DW+xZKP1TwfZ9qlE61aip7wUl5KM50zujogjOnXiw8Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)