UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Aj1v5vdlMd60IUpxcn6gdn1SMqFEFaLcpSMN3HQHHo='
WHERE
key_id = 'd98ebae627f5980a2ac6cd54ce93bc417b65836204a58adc8a832e814e81d6cd'
AND (
token = '2Aj1v5vdlMd60IUpxcn6gdn1SMqFEFaLcpSMN3HQHHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)