UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sZioVN8ZtYAHSHQzxGWBw0Plub42xyVY8RING3qxJGc='
WHERE
key_id = '3f2190ef6e3c0d9c10bc21c4ca5313eb8471c9823b023b6bf4113c5374d6c627'
AND (
token = 'sZioVN8ZtYAHSHQzxGWBw0Plub42xyVY8RING3qxJGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)