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