UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b9IDqgykNr3uKHKtwUkMKgQaI7c1ltHcQ6Jv1gm9nm4='
WHERE
key_id = '788467a80bca51752ccf0ae6b80c2167916c39f7b74e218e624feeda988f8921'
AND (
token = 'b9IDqgykNr3uKHKtwUkMKgQaI7c1ltHcQ6Jv1gm9nm4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)