UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm3ORR/gXxp2ptzsXcPHGl835ny1ts639l7Mzt4m5NwI='
WHERE
key_id = 'ec3795650e64eb745a7d5984618b2d1cd530951bf6b23db50f8eea8c3dafc1df'
AND (
token = 'm3ORR/gXxp2ptzsXcPHGl835ny1ts639l7Mzt4m5NwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)