UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p6Y0D9sxpoS3sHoTfxEchB+MPR3bwF27KSdPwnaAMWs='
WHERE
key_id = 'a087d608acd0beba9a459c0ed44de7f03e49083a9654fbcd93e683593d2e575e'
AND (
token = 'p6Y0D9sxpoS3sHoTfxEchB+MPR3bwF27KSdPwnaAMWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)