UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ShsOyAH61leIuEWZUx5Iy6DHua+PgLZbFF8zljLUqFE='
WHERE
key_id = '8492a0bb20d3a2bd392086b206d6745cb8f25a3ace32cf772c6855b8fdfa66ad'
AND (
token = 'ShsOyAH61leIuEWZUx5Iy6DHua+PgLZbFF8zljLUqFE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)