UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'znGabqGk7vPwxRN1fV8ppobr9KgE9jyW/dX/i7Ojykk='
WHERE
key_id = 'b8992c0a3aa3c73aeba7916acdc045353b5d0b1cd2aed5f156812ac1b8b54a9a'
AND (
token = 'znGabqGk7vPwxRN1fV8ppobr9KgE9jyW/dX/i7Ojykk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)