UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mT5FDRlUjJ7aPOR6aivAad+7BhZUxC/u9UsmsHxEZZE='
WHERE
key_id = 'ee551395212bc11d20eedd475e2a49161405a3decf42d7b79afe2176dc0ced9d'
AND (
token = 'mT5FDRlUjJ7aPOR6aivAad+7BhZUxC/u9UsmsHxEZZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)