UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gBAPqJVezP5tPlZQsvjI4i2X7AizOh1u0p7d+mvSimQ='
WHERE
key_id = '09343cf01a3df1f46cb0d99c0a2cd86e08df2ca7963d892a16f2972400119e50'
AND (
token = 'gBAPqJVezP5tPlZQsvjI4i2X7AizOh1u0p7d+mvSimQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)