UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FjnUu7Ad7u/FeSnDDK+pZSm+QGG8wZNb0pBAI5ObBpo='
WHERE
key_id = '2cc12b33465fb9d2af0847ecd1d6be5102e76bc08f5b8bf51f5c9cf95e24f706'
AND (
token = 'FjnUu7Ad7u/FeSnDDK+pZSm+QGG8wZNb0pBAI5ObBpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)