UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iJgBcVVgzjIbD5d3rXlkHfCmztgBmx3y1pSjyf3PS0w='
WHERE
key_id = '0c050ceffbab0a9a065c38dad11194f234da12aab1ba9dd7bae39fe8bf4b2a57'
AND (
token = 'iJgBcVVgzjIbD5d3rXlkHfCmztgBmx3y1pSjyf3PS0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)