UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hp70INRm7XR+MOq7GbMvmiQ2EfGGZm4psuhDlwlSh1U='
WHERE
key_id = '59675c014d47a14b80c9d98e8d431daaaac8735c04e739b23311c7f3cbb996da'
AND (
token = 'hp70INRm7XR+MOq7GbMvmiQ2EfGGZm4psuhDlwlSh1U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)