UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S9h3sMvx3/kXrYUl/3azItJyGKc6GRbsqLnpqsYCY/U='
WHERE
key_id = '7c2a0b5a3e1f893f2878577bc7254844879f9b42914f6a6753945b10970ba46c'
AND (
token = 'S9h3sMvx3/kXrYUl/3azItJyGKc6GRbsqLnpqsYCY/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)